package com.jzy.stock.kufangguishu.mapper;

import com.jzy.stock.kufangguishu.model.*;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * Created by PC on 2022/7/11.
 */
@Mapper
public interface GuiShuMapper {
    List<ReservoirAreaVo> queryData(KuFangGuiShuSelectVo kuFangGuiShuSelectVo);

    int queryCount(KuFangGuiShuSelectVo kuFangGuiShuSelectVo);

    List<FaRenVo> queryBylegalPersonName(UserVo userVo);

    //ReservoirAreaVo queryById(Integer id);

    void updateStatus(ReservoirAreaVo stockidentityUpdate);

    StockroomVo queryByKuFangId(Integer id);

    //List<ReservoirAreaVo> queryByKuFangCode(String code);

    //List<KuWeiVo> queryKuquCode(String code);

    @Select("select * from stockroom")
    List<queryAllVo> queryKuFangAll();
    @Select("select * from reservoir_area where wareHouseCode = #{wareHouseCode}")
    List<queryAllVo> queryKuQuAll(String kuFangCode);
    @Select("select * from kuwei where storageSectionCode = #{storageSectionCode}")
    List<queryAllVo> queryByKuWeiAll(String kuQuCode);

    ReservoirAreaVo queryById(Integer id);

    List<ReservoirAreaVo> queryByKuFangCode(String code);

    List<KuWeiVo> queryKuquCode(String code);
}
